﻿CREATE PROCEDURE [dbo].[DeleteProject]
@ProjectID INT
AS
DELETE FROM 
	Milestones
WHERE ProjectID = @ProjectID

DELETE FROM 
	ProjectCategories
WHERE ProjectID = @ProjectID

EXEC ClearProjectMembers @ProjectID = @ProjectID

DELETE FROM 
	Projects 

WHERE 
	ProjectID = @ProjectID

